﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'InspeckRecord_View')
BEGIN
  DROP  View InspeckRecord_View
END
GO
CREATE View InspeckRecord_View 
AS
  SELECT A.*,B.EnterpriseName FROM InspeckRecord A JOIN Enterprises_View B ON A.EnterpriseID=B.EnterpriseID
GO
